Dashboard of Moderna vs Pfizer vaccination¶

Part 1: Moderna analysis¶

In [18]:
import pandas as pd
import matplotlib.pyplot as plt

# Load the data into a pandas dataframe
df = pd.read_csv("cdc-moderna-covid-19-vaccine-distribution-by-state.csv")

# Group the data by name
grouped = df.groupby("names")

# Calculate the sum of the allocations for each name
allocations_sum = grouped.sum()

# Calculate the mean of the allocations for each name
allocations_mean = grouped.mean()

# Print the sum of 1st dose allocations by name
print("Sum of 1st Dose Allocations by Name")
allocations_sum["_1st_dose_allocations"].plot(kind="bar", title="Sum of 1st Dose Allocations by Name")
plt.show()
C:\Users\adri_\AppData\Local\Temp\ipykernel_3204\126274806.py:11: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.
  allocations_sum = grouped.sum()
C:\Users\adri_\AppData\Local\Temp\ipykernel_3204\126274806.py:14: FutureWarning: The default value of numeric_only in DataFrameGroupBy.mean is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.
  allocations_mean = grouped.mean()
Sum of 1st Dose Allocations by Name
In [12]:
# Print the sum of 2nd dose allocations by name
print("Sum of 2nd Dose Allocations by Name")
allocations_sum["_2nd_dose_allocations"].plot(kind="bar", title="Sum of 2nd Dose Allocations by Name")
plt.show()
Sum of 2nd Dose Allocations by Name
In [13]:
# Print the mean of 1st dose allocations by name
print("Mean of 1st Dose Allocations by Name")
allocations_mean["_1st_dose_allocations"].plot(kind="bar", title="Mean of 1st Dose Allocations by Name")
plt.show()
Mean of 1st Dose Allocations by Name
In [14]:
# Print the mean of 2nd dose allocations by name
print("Mean of 2nd Dose Allocations by Name")
allocations_mean["_2nd_dose_allocations"].plot(kind="bar", title="Mean of 2nd Dose Allocations by Name")
plt.show()
Mean of 2nd Dose Allocations by Name
In [16]:
df.plot(x="week_of_allocations", y=["_1st_dose_allocations", "_2nd_dose_allocations"])
plt.xlabel("Week of Allocations")
plt.ylabel("Number of Doses Allocated")
plt.legend(["1st Dose Allocations", "2nd Dose Allocations"])
plt.title("Allocations Over Time")
plt.show()
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FC6A90> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FC6490> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
In [17]:
for name, group in grouped:
    group.plot(x="week_of_allocations", y=["_1st_dose_allocations", "_2nd_dose_allocations"], title=name)
    plt.xlabel("Week of Allocations")
    plt.ylabel("Number of Doses Allocated")
    plt.legend(["1st Dose Allocations", "2nd Dose Allocations"])
    plt.show()
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740968760> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740968AC0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F023A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F1A0D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174233C400> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742345280> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174234DD60> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742340190> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174229ED00> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174229EFA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C48280> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C48760> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C2AD00> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C2A3A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FF4DF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117431F46D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117420155E0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F93C40> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405592E0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402BC580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740B86CD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740B86B20> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117429274C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740B8C3A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742019A00> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742019820> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742357B20> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117423576A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740EF0730> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C6F670> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402C81F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FCCC70> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740CB0640> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740CB0B80> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740954070> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174070F250> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406C9AF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406C9C70> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404CF8B0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404CF100> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173F17BDF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173F17B640> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404C5F40> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404C5880> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173F11D4C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173F121070> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402F5E50> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402F5D90> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740336370> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740327130> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740042520> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740042610> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FE54F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FE5FA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C880A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F734F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740628130> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406289D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402400A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740240CA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406287C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406289D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740964850> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740964F70> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117403C43D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117403C4FA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117428FE0D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117428FE0A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117429A8580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117429A8340> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174007CB20> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740626C10> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174312B0D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174312BA30> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011743014CA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011743014B80> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011743212310> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117432125E0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740436B20> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404367F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011743212A30> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011743212D00> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117428940D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742F9F400> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740254CD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402360D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C8F220> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C8F5E0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742FE6490> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406769D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C84700> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C84AC0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742FD1880> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742FD1460> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405D00A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405D0460> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FDF400> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011741FDF7C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740474700> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740474880> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740EDEF70> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740EDE580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740BB8A30> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740BB84C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742F9F6D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742970AF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117428A8BE0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117428A8A60> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740498DF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740498D00> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117408EAD30> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402120A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740226790> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117408CEFA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740CAA7F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402970A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740CD4BE0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740CD4970> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174019B850> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174019B550> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742078A90> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402EF070> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174019B2B0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174019B760> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173FFEE160> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173FFEE730> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)

Pfizer analysis¶

In [19]:
import pandas as pd
import matplotlib.pyplot as plt

# Load the data into a pandas dataframe
df = pd.read_csv("cdc-pfizer-covid-19-vaccine-distribution-by-state.csv")

# Group the data by name
grouped = df.groupby("names")

# Calculate the sum of the allocations for each name
allocations_sum = grouped.sum()

# Calculate the mean of the allocations for each name
allocations_mean = grouped.mean()

# Print the sum of 1st dose allocations by name
print("Sum of 1st Dose Allocations by Name")
allocations_sum["_1st_dose_allocations"].plot(kind="bar", title="Sum of 1st Dose Allocations by Name")
plt.show()
C:\Users\adri_\AppData\Local\Temp\ipykernel_3204\2511742929.py:11: FutureWarning: The default value of numeric_only in DataFrameGroupBy.sum is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.
  allocations_sum = grouped.sum()
C:\Users\adri_\AppData\Local\Temp\ipykernel_3204\2511742929.py:14: FutureWarning: The default value of numeric_only in DataFrameGroupBy.mean is deprecated. In a future version, numeric_only will default to False. Either specify numeric_only or select only columns which should be valid for the function.
  allocations_mean = grouped.mean()
Sum of 1st Dose Allocations by Name
In [20]:
# Print the sum of 2nd dose allocations by name
print("Sum of 2nd Dose Allocations by Name")
allocations_sum["_2nd_dose_allocations"].plot(kind="bar", title="Sum of 2nd Dose Allocations by Name")
plt.show()
Sum of 2nd Dose Allocations by Name
In [21]:
# Print the mean of 1st dose allocations by name
print("Mean of 1st Dose Allocations by Name")
allocations_mean["_1st_dose_allocations"].plot(kind="bar", title="Mean of 1st Dose Allocations by Name")
plt.show()
Mean of 1st Dose Allocations by Name
In [22]:
# Print the mean of 2nd dose allocations by name
print("Mean of 2nd Dose Allocations by Name")
allocations_mean["_2nd_dose_allocations"].plot(kind="bar", title="Mean of 2nd Dose Allocations by Name")
plt.show()
Mean of 2nd Dose Allocations by Name
In [23]:
df.plot(x="week_of_allocations", y=["_1st_dose_allocations", "_2nd_dose_allocations"])
plt.xlabel("Week of Allocations")
plt.ylabel("Number of Doses Allocated")
plt.legend(["1st Dose Allocations", "2nd Dose Allocations"])
plt.title("Allocations Over Time")
plt.show()
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740663F40> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740587340> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
In [24]:
for name, group in grouped:
    group.plot(x="week_of_allocations", y=["_1st_dose_allocations", "_2nd_dose_allocations"], title=name)
    plt.xlabel("Week of Allocations")
    plt.ylabel("Number of Doses Allocated")
    plt.legend(["1st Dose Allocations", "2nd Dose Allocations"])
    plt.show()
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742FBD580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742FBD940> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742340D60> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742340C10> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740415910> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740415CD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174228CD00> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742231A60> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174072DE80> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174073E280> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742259C40> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117422592B0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742337070> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011742337A60> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F73190> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740447DC0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F038E0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F036D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405DAC70> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404DA070> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402C8640> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402C8AC0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402DAFD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402DA0A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117400F06A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117400F03A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402F5FA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117409A53A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174011F3A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174011F670> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740EB05E0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740EB0FA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173FEF1460> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402086A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740B86BB0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740B86FD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F071F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F07D30> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174203CF70> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174203CB50> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117408A4D00> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117408A4940> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740509A90> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740509E20> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174204BF70> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174204B850> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173C755850> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173FFC3CD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173F121070> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117402EF850> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740628E80> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406283A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404B5DC0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404B50D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740FB5CD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174207F250> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117401E61F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117401E6C10> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174025DA90> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174025DD60> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740212AF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740212580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740389130> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C0E580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406BE970> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406BEFD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740368A90> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174063B250> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174039AC40> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174297C430> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740916E80> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740916400> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405D08B0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174012EF40> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117428A2460> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117428A2970> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405D0940> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405D02E0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404873A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C63850> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740239160> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740239880> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406639A0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001173FFEEA60> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174063E550> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174063E910> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406AB3D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740671250> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740697E80> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740697490> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117431FEF10> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174321A310> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740531730> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117405319D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740D0F460> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740D0F700> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740CBBC40> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174053B040> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174321ACD0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174321A610> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406AB580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117406ABAC0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740BD7310> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740BD7580> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740F631F0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740662550> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C01B50> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740C01640> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174302F7C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174302F4C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740BDF7C0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740410DF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174068F430> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174068FAF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740BDD3D0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740BDDA90> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174207FCA0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174207F700> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740042400> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740196670> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174014DE50> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174014D040> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x000001174012E5B0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x0000011740042610> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_1st_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404ED970> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
C:\Users\adri_\anaconda3\envs\cryptoanalysis\lib\site-packages\pandas\plotting\_matplotlib\core.py:807: UserWarning: The label '_2nd_dose_allocations' of <matplotlib.lines.Line2D object at 0x00000117404EDDF0> starts with '_'. It is thus excluded from the legend.
  ax.legend(handles, labels, loc="best", title=title)
In [ ]: